﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="kartrisConfigData" targetNamespace="http://tempuri.org/kartrisConfigData.xsd" xmlns:mstns="http://tempuri.org/kartrisConfigData.xsd" xmlns="http://tempuri.org/kartrisConfigData.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="2" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="kartrisSQLConnStr" IsAppSettingsProperty="true" Modifier="Assembly" Name="kartrisSQLConnStr (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.kartrisSQLConnStr.ConnectionString" Provider="System.Data.SqlClient" />
          <Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="KartrisSQLConnection" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="KartrisSQLConnection (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.KartrisSQLConnection.ConnectionString" Provider="System.Data.SqlClient" />
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="kartrisSQLConnection" IsAppSettingsProperty="true" Modifier="Assembly" Name="kartrisSQLConnection (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Kartris.My.MySettings.GlobalReference.Default.kartrisSQLConnection" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ConfigTblAdptr" GeneratorDataComponentClassName="ConfigTblAdptr" Name="Config" UserDataComponentName="ConfigTblAdptr">
            <MainSource>
              <DbSource ConnectionRef="KartrisSQLConnection (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="GetData">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.[_spKartrisConfig_GetByName]</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CFG_Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CFG_Name" DataSetColumn="CFG_Name" />
              <Mapping SourceColumn="CFG_Value" DataSetColumn="CFG_Value" />
              <Mapping SourceColumn="CFG_DataType" DataSetColumn="CFG_DataType" />
              <Mapping SourceColumn="CFG_DisplayType" DataSetColumn="CFG_DisplayType" />
              <Mapping SourceColumn="CFG_DisplayInfo" DataSetColumn="CFG_DisplayInfo" />
              <Mapping SourceColumn="CFG_Description" DataSetColumn="CFG_Description" />
              <Mapping SourceColumn="CFG_VersionAdded" DataSetColumn="CFG_VersionAdded" />
              <Mapping SourceColumn="CFG_DefaultValue" DataSetColumn="CFG_DefaultValue" />
              <Mapping SourceColumn="CactuShopName_DEPRECATED" DataSetColumn="CactuShopName_DEPRECATED" />
              <Mapping SourceColumn="CFG_Important" DataSetColumn="CFG_Important" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="KartrisSQLConnection (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="_GetConfigByName" GeneratorSourceName="FillConfigByName" GetMethodModifier="Public" GetMethodName="_GetConfigByName" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="_GetConfigByName" UserSourceName="_GetConfigByName">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.[_spKartrisConfig_GetByName]</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CFG_Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="KartrisSQLConnection (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="_GetConfigDesc" GeneratorSourceName="FillBy1" GetMethodModifier="Public" GetMethodName="_GetConfigDesc" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="_GetConfigDesc" UserSourceName="_GetConfigDesc">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.[_spKartrisConfig_GetDesc]</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CFG_Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="KartrisSQLConnection (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="_GetImportantConfig" GetMethodModifier="Public" GetMethodName="_GetImportantConfig" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="_GetImportantConfig" UserSourceName="_GetImportantConfig">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.[_spKartrisConfig_GetImportant]</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="KartrisSQLConnection (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="_SearchConfig" GeneratorSourceName="FillBy" GetMethodModifier="Public" GetMethodName="_SearchConfig" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="_SearchConfig" UserSourceName="_SearchConfig">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.[_spKartrisConfig_Search]</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@ConfigKey" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@ImportantConfig" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ConfigCacheTblAdptr" GeneratorDataComponentClassName="ConfigCacheTblAdptr" Name="ConfigCache" UserDataComponentName="ConfigCacheTblAdptr">
            <MainSource>
              <DbSource ConnectionRef="KartrisSQLConnection (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="false" GeneratorGetMethodName="_GetConfigCacheData" GetMethodModifier="Public" GetMethodName="_GetConfigCacheData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="_GetConfigCacheData" UserSourceName="_GetConfigCacheData">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.[_spKartrisConfig_GetforCache]</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CFG_Name" DataSetColumn="CFG_Name" />
              <Mapping SourceColumn="CFG_Value" DataSetColumn="CFG_Value" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="kartrisConfigData" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msdata:EnforceConstraints="False" msprop:Generator_UserDSName="kartrisConfigData" msprop:Generator_DataSetName="kartrisConfigData">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Config" msprop:Generator_UserTableName="Config" msprop:Generator_RowDeletedName="ConfigRowDeleted" msprop:Generator_RowChangedName="ConfigRowChanged" msprop:Generator_RowClassName="ConfigRow" msprop:Generator_RowChangingName="ConfigRowChanging" msprop:Generator_RowEvArgName="ConfigRowChangeEvent" msprop:Generator_RowEvHandlerName="ConfigRowChangeEventHandler" msprop:Generator_TableClassName="ConfigDataTable" msprop:Generator_TableVarName="tableConfig" msprop:Generator_RowDeletingName="ConfigRowDeleting" msprop:Generator_TablePropName="Config">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CFG_Name" msprop:Generator_UserColumnName="CFG_Name" msprop:Generator_ColumnVarNameInTable="columnCFG_Name" msprop:Generator_ColumnPropNameInRow="CFG_Name" msprop:Generator_ColumnPropNameInTable="CFG_NameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CFG_Value" msprop:Generator_UserColumnName="CFG_Value" msprop:Generator_ColumnVarNameInTable="columnCFG_Value" msprop:Generator_ColumnPropNameInRow="CFG_Value" msprop:Generator_ColumnPropNameInTable="CFG_ValueColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CFG_DataType" msprop:Generator_UserColumnName="CFG_DataType" msprop:Generator_ColumnVarNameInTable="columnCFG_DataType" msprop:Generator_ColumnPropNameInRow="CFG_DataType" msprop:Generator_ColumnPropNameInTable="CFG_DataTypeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CFG_DisplayType" msprop:Generator_UserColumnName="CFG_DisplayType" msprop:Generator_ColumnVarNameInTable="columnCFG_DisplayType" msprop:Generator_ColumnPropNameInRow="CFG_DisplayType" msprop:Generator_ColumnPropNameInTable="CFG_DisplayTypeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CFG_DisplayInfo" msprop:Generator_UserColumnName="CFG_DisplayInfo" msprop:Generator_ColumnVarNameInTable="columnCFG_DisplayInfo" msprop:Generator_ColumnPropNameInRow="CFG_DisplayInfo" msprop:Generator_ColumnPropNameInTable="CFG_DisplayInfoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CFG_Description" msprop:Generator_UserColumnName="CFG_Description" msprop:Generator_ColumnVarNameInTable="columnCFG_Description" msprop:Generator_ColumnPropNameInRow="CFG_Description" msprop:Generator_ColumnPropNameInTable="CFG_DescriptionColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CFG_VersionAdded" msprop:Generator_UserColumnName="CFG_VersionAdded" msprop:Generator_ColumnVarNameInTable="columnCFG_VersionAdded" msprop:Generator_ColumnPropNameInRow="CFG_VersionAdded" msprop:Generator_ColumnPropNameInTable="CFG_VersionAddedColumn" type="xs:float" minOccurs="0" />
              <xs:element name="CFG_DefaultValue" msprop:Generator_UserColumnName="CFG_DefaultValue" msprop:Generator_ColumnVarNameInTable="columnCFG_DefaultValue" msprop:Generator_ColumnPropNameInRow="CFG_DefaultValue" msprop:Generator_ColumnPropNameInTable="CFG_DefaultValueColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CactuShopName_DEPRECATED" msprop:Generator_UserColumnName="CactuShopName_DEPRECATED" msprop:Generator_ColumnPropNameInRow="CactuShopName_DEPRECATED" msprop:Generator_ColumnVarNameInTable="columnCactuShopName_DEPRECATED" msprop:Generator_ColumnPropNameInTable="CactuShopName_DEPRECATEDColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CFG_Important" msprop:Generator_UserColumnName="CFG_Important" msprop:Generator_ColumnPropNameInRow="CFG_Important" msprop:Generator_ColumnVarNameInTable="columnCFG_Important" msprop:Generator_ColumnPropNameInTable="CFG_ImportantColumn" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ConfigCache" msprop:Generator_UserTableName="ConfigCache" msprop:Generator_RowDeletedName="ConfigCacheRowDeleted" msprop:Generator_RowChangedName="ConfigCacheRowChanged" msprop:Generator_RowClassName="ConfigCacheRow" msprop:Generator_RowChangingName="ConfigCacheRowChanging" msprop:Generator_RowEvArgName="ConfigCacheRowChangeEvent" msprop:Generator_RowEvHandlerName="ConfigCacheRowChangeEventHandler" msprop:Generator_TableClassName="ConfigCacheDataTable" msprop:Generator_TableVarName="tableConfigCache" msprop:Generator_RowDeletingName="ConfigCacheRowDeleting" msprop:Generator_TablePropName="ConfigCache">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CFG_Name" msprop:Generator_UserColumnName="CFG_Name" msprop:Generator_ColumnPropNameInRow="CFG_Name" msprop:Generator_ColumnVarNameInTable="columnCFG_Name" msprop:Generator_ColumnPropNameInTable="CFG_NameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CFG_Value" msprop:Generator_UserColumnName="CFG_Value" msprop:Generator_ColumnPropNameInRow="CFG_Value" msprop:Generator_ColumnVarNameInTable="columnCFG_Value" msprop:Generator_ColumnPropNameInTable="CFG_ValueColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ConfigCache" />
      <xs:field xpath="mstns:CFG_Name" />
    </xs:unique>
  </xs:element>
</xs:schema>